Summary: Shootings in USA in 2018

This page displays various information about the shootings that occured in 2018. This data was collected from GunViolence.org. The total number of shootings that occured in 2018 is 339 and the total number of lives lost due to shootings is 373. Pompano Beach (Parkland) is the city most impacted (in terms of deaths) by shootings that occurred in 2018 with 17 deaths. The state that lost the most lives in one incident is Florida with 17 deaths.

Casualties are defined as number of injuries and deaths that occured due to an incident. Pompano Beach (Parkland) had the most number of casualties with 34 casualites. Santa Fe had the second most number of casualties.

Summary Table

The table below shows the shows the total casualties due to shootings in 2018, and the number of deaths and injuries as well. From this table we can see which states were affected the most due to shootings in terms of number of deaths, casualties or injuries

State Dead Injured Casualties
Alabama 12 55 67
Arizona 4 5 9
Arkansas 7 17 24
California 50 136 186
Colorado 9 27 36
Connecticut 0 8 8
Delaware 5 0 5
District of Columbia 2 23 25
Florida 48 132 180
Georgia 3 33 36
Illinois 21 150 171
Indiana 10 27 37
Kansas 1 11 12
Kentucky 7 25 32
Louisiana 15 50 65
Maryland 13 31 44
Massachusetts 0 4 4
Michigan 10 28 38
Minnesota 1 14 15
Mississippi 1 17 18
Missouri 12 52 64
Nebraska 1 16 17
Nevada 3 15 18
New Jersey 4 54 58
New Mexico 5 4 9
New York 5 53 58
North Carolina 14 37 51
Ohio 13 46 59
Oklahoma 2 19 21
Pennsylvania 35 63 98
South Carolina 5 19 24
Tennessee 19 68 87
Texas 29 62 91
Utah 0 4 4
Virginia 2 17 19
Washington 4 9 13
Wisconsin 1 16 17

This table below only shows the top 5 states that were affected by shootings in 2018 and displays the number of casualties further divided into injuries and deaths for each of the 5 states.

State Dead Injured Casualties
California 50 136 186
Florida 48 132 180
Illinois 21 150 171
Pennsylvania 35 63 98
Texas 29 62 91

While Florida has the most deaths and casualties in one single incident, from the table above it is clear that California has the highest number of deaths, injuries and casualties from all the shootings that occured in 2018.

We can also see that not all shots are fatal as there is more injuries due to shootings than deaths. However, looking at the table with all the states information present we can see that this is not always the case. Delaware is an example where all casualties were deaths.

Specific Incident: Thousand Oaks, California

I selected this incident by reading the table above and identifying which state had the most number of casualties. The state with the highest number of casualties is California with 186 casualties. Thousand Oaks, California had the highest number of casualites in this state. This incident occured on November 7, 2018 at 99 Rolling Oaks Dr, Thousand Oaks. This unfortunate incident occured at the Borderline Bar & Grill in Thousand Oaks, California around 11pm. The number of casualties were 15 out of which 13 died and 2 were injured.

Interactive Visualisation

This visualisation below will show the location of each shooting that occured in 2018 and the size of the marker will be based on the number of casualites (number injured and dead). From this visualisation you should be able to get a view of the locations of shooting incidents, and the relative comparasion of casualties. When you hover over each point the extra information will be provided such as the number of injuries, number of deaths, and the location of the incident.

From this visualisation we can see that,

Interactive Plot

I wanted to see what is the percentage of death in each state due to shootings. I chose to display the information as a scatterplot as this is a measurment of two continuous variables (death rates and total shootings) so the visually impactful way to display this information is as a scatterplot where the maximum and minimum values are easily identified and you can see the position of one state relative to other states.

To get the death percentage information, I created a new dataframe that only includes, state, number of casualties and number of deaths and a new column that includes death rates (which are calculated using the information provided in the orginal dataset)

From the plot the following insights are evident: